Finding ID | Version | Rule ID | IA Controls | Severity |
---|---|---|---|---|
V-251623 | IDMS-DB-000520 | SV-251623r807736_rule | Medium |
Description |
---|
When the use of dynamic SQL is necessary, the code should be written so that the invalid data can be found and the appropriate action taken. |
STIG | Date |
---|---|
CA IDMS Security Technical Implementation Guide | 2022-09-07 |
Check Text ( C-55058r807734_chk ) |
---|
If dynamic code execution is used and identified user input is not validity checked user input, this is a finding. If SQL-defined tables, DISPLAY TABLE If network-defined records, DISPLAY SCHEMA or DISPLAY RECORD. If there is no CALL to a procedure BEFORE STORE and BEFORE MODIFY, this is a finding. If the procedure does not validate the non-exempt columns, this is a finding. Other applications and front-ends using mapping can use the automatic editing feature and edit and code tables to verify that an input value is valid. |
Fix Text (F-55012r807735_fix) |
---|
For SQL-defined tables, ALTER TABLE For network-defined records, MODIFY Other applications and front-ends using mapping can use the automatic editing feature and edit and code tables to verify that an input value is valid. |